{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\r"
     ]
    }
   ],
   "source": [
    "#-*-coding=utf-8-*-\n",
    "'''\n",
    "每天复盘\n",
    "'''\n",
    "from setting import get_engine\n",
    "import datetime\n",
    "import pandas as pd\n",
    "import tushare as ts\n",
    "today= datetime.datetime.now().strftime('%Y-%m-%d')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "engine = get_engine('db_daily')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_sql('tb_basic_info',engine,index_col='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "hainan_code = df[df['area']==u'海南']['code'].values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "api=ts.get_apis()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[Getting data:]############################################################"
     ]
    }
   ],
   "source": [
    "today_market =ts.get_today_all()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>changepercent</th>\n",
       "      <th>trade</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>settlement</th>\n",
       "      <th>volume</th>\n",
       "      <th>turnoverratio</th>\n",
       "      <th>amount</th>\n",
       "      <th>per</th>\n",
       "      <th>pb</th>\n",
       "      <th>mktcap</th>\n",
       "      <th>nmc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>603999</td>\n",
       "      <td>读者传媒</td>\n",
       "      <td>-2.685</td>\n",
       "      <td>5.80</td>\n",
       "      <td>5.94</td>\n",
       "      <td>5.95</td>\n",
       "      <td>5.77</td>\n",
       "      <td>5.96</td>\n",
       "      <td>3403320.0</td>\n",
       "      <td>1.47714</td>\n",
       "      <td>19956189.0</td>\n",
       "      <td>44.275</td>\n",
       "      <td>1.972</td>\n",
       "      <td>3.340800e+05</td>\n",
       "      <td>1.336320e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>603998</td>\n",
       "      <td>方盛制药</td>\n",
       "      <td>-1.754</td>\n",
       "      <td>8.40</td>\n",
       "      <td>8.65</td>\n",
       "      <td>8.65</td>\n",
       "      <td>8.33</td>\n",
       "      <td>8.55</td>\n",
       "      <td>1614356.0</td>\n",
       "      <td>0.37967</td>\n",
       "      <td>13724010.0</td>\n",
       "      <td>60.000</td>\n",
       "      <td>3.591</td>\n",
       "      <td>3.619866e+05</td>\n",
       "      <td>3.571652e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>603997</td>\n",
       "      <td>继峰股份</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10.87</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10.87</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23.630</td>\n",
       "      <td>3.837</td>\n",
       "      <td>6.932008e+05</td>\n",
       "      <td>6.848100e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>603996</td>\n",
       "      <td>中新科技</td>\n",
       "      <td>9.990</td>\n",
       "      <td>10.68</td>\n",
       "      <td>9.57</td>\n",
       "      <td>10.68</td>\n",
       "      <td>9.51</td>\n",
       "      <td>9.71</td>\n",
       "      <td>24678982.0</td>\n",
       "      <td>23.89638</td>\n",
       "      <td>252657161.0</td>\n",
       "      <td>21.796</td>\n",
       "      <td>2.123</td>\n",
       "      <td>3.205602e+05</td>\n",
       "      <td>1.102977e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>603993</td>\n",
       "      <td>洛阳钼业</td>\n",
       "      <td>-2.385</td>\n",
       "      <td>6.14</td>\n",
       "      <td>6.26</td>\n",
       "      <td>6.27</td>\n",
       "      <td>6.08</td>\n",
       "      <td>6.29</td>\n",
       "      <td>69942520.0</td>\n",
       "      <td>0.53994</td>\n",
       "      <td>430950440.0</td>\n",
       "      <td>43.857</td>\n",
       "      <td>3.408</td>\n",
       "      <td>1.326193e+07</td>\n",
       "      <td>7.953591e+06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     code  name  changepercent  trade  open   high   low  settlement  \\\n",
       "0  603999  读者传媒         -2.685   5.80  5.94   5.95  5.77        5.96   \n",
       "1  603998  方盛制药         -1.754   8.40  8.65   8.65  8.33        8.55   \n",
       "2  603997  继峰股份          0.000  10.87  0.00   0.00  0.00       10.87   \n",
       "3  603996  中新科技          9.990  10.68  9.57  10.68  9.51        9.71   \n",
       "4  603993  洛阳钼业         -2.385   6.14  6.26   6.27  6.08        6.29   \n",
       "\n",
       "       volume  turnoverratio       amount     per     pb        mktcap  \\\n",
       "0   3403320.0        1.47714   19956189.0  44.275  1.972  3.340800e+05   \n",
       "1   1614356.0        0.37967   13724010.0  60.000  3.591  3.619866e+05   \n",
       "2         0.0        0.00000          0.0  23.630  3.837  6.932008e+05   \n",
       "3  24678982.0       23.89638  252657161.0  21.796  2.123  3.205602e+05   \n",
       "4  69942520.0        0.53994  430950440.0  43.857  3.408  1.326193e+07   \n",
       "\n",
       "            nmc  \n",
       "0  1.336320e+05  \n",
       "1  3.571652e+05  \n",
       "2  6.848100e+05  \n",
       "3  1.102977e+05  \n",
       "4  7.953591e+06  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "today_market.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\python3\\lib\\site-packages\\pymysql\\cursors.py:170: Warning: (1366, \"Incorrect string value: '\\\\xD6\\\\xD0\\\\xB9\\\\xFA\\\\xB1\\\\xEA...' for column 'VARIABLE_VALUE' at row 480\")\n",
      "  result = self._query(query)\n"
     ]
    }
   ],
   "source": [
    "today_market.to_sql('tb_temp',engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>changepercent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>375</th>\n",
       "      <td>海汽集团</td>\n",
       "      <td>9.991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433</th>\n",
       "      <td>海南矿业</td>\n",
       "      <td>10.013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>558</th>\n",
       "      <td>海南橡胶</td>\n",
       "      <td>10.032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>640</th>\n",
       "      <td>览海投资</td>\n",
       "      <td>9.960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>755</th>\n",
       "      <td>洲际油气</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>927</th>\n",
       "      <td>海航创新</td>\n",
       "      <td>9.978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>959</th>\n",
       "      <td>海航基础</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1146</th>\n",
       "      <td>广晟有色</td>\n",
       "      <td>6.871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1161</th>\n",
       "      <td>海南椰岛</td>\n",
       "      <td>9.973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1174</th>\n",
       "      <td>海航控股</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1184</th>\n",
       "      <td>罗顿发展</td>\n",
       "      <td>9.977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1454</th>\n",
       "      <td>普利制药</td>\n",
       "      <td>3.554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1886</th>\n",
       "      <td>神农基因</td>\n",
       "      <td>10.074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1988</th>\n",
       "      <td>康芝药业</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2134</th>\n",
       "      <td>钧达股份</td>\n",
       "      <td>9.982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2293</th>\n",
       "      <td>双成药业</td>\n",
       "      <td>9.986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2390</th>\n",
       "      <td>海南瑞泽</td>\n",
       "      <td>10.008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2665</th>\n",
       "      <td>海峡股份</td>\n",
       "      <td>9.988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3024</th>\n",
       "      <td>欣龙控股</td>\n",
       "      <td>10.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3075</th>\n",
       "      <td>海南高速</td>\n",
       "      <td>9.957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3134</th>\n",
       "      <td>华闻传媒</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3168</th>\n",
       "      <td>罗 牛 山</td>\n",
       "      <td>10.010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3230</th>\n",
       "      <td>中钨高新</td>\n",
       "      <td>10.035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3257</th>\n",
       "      <td>大东海A</td>\n",
       "      <td>10.034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3287</th>\n",
       "      <td>海马汽车</td>\n",
       "      <td>10.072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3288</th>\n",
       "      <td>新大洲Ａ</td>\n",
       "      <td>10.078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3291</th>\n",
       "      <td>海德股份</td>\n",
       "      <td>10.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3292</th>\n",
       "      <td>海南海药</td>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3343</th>\n",
       "      <td>京粮控股</td>\n",
       "      <td>10.011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3345</th>\n",
       "      <td>海虹控股</td>\n",
       "      <td>5.735</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       name  changepercent\n",
       "375    海汽集团          9.991\n",
       "433    海南矿业         10.013\n",
       "558    海南橡胶         10.032\n",
       "640    览海投资          9.960\n",
       "755    洲际油气          0.000\n",
       "927    海航创新          9.978\n",
       "959    海航基础          0.000\n",
       "1146   广晟有色          6.871\n",
       "1161   海南椰岛          9.973\n",
       "1174   海航控股          0.000\n",
       "1184   罗顿发展          9.977\n",
       "1454   普利制药          3.554\n",
       "1886   神农基因         10.074\n",
       "1988   康芝药业          0.000\n",
       "2134   钧达股份          9.982\n",
       "2293   双成药业          9.986\n",
       "2390   海南瑞泽         10.008\n",
       "2665   海峡股份          9.988\n",
       "3024   欣龙控股         10.030\n",
       "3075   海南高速          9.957\n",
       "3134   华闻传媒          0.000\n",
       "3168  罗 牛 山         10.010\n",
       "3230   中钨高新         10.035\n",
       "3257   大东海A         10.034\n",
       "3287   海马汽车         10.072\n",
       "3288   新大洲Ａ         10.078\n",
       "3291   海德股份         10.000\n",
       "3292   海南海药          0.000\n",
       "3343   京粮控股         10.011\n",
       "3345   海虹控股          5.735"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "today_market[today_market['code'].isin(hainan_code)][['name','changepercent']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "engine = get_engine('db_daily')\n",
    "\n",
    "df = pd.read_sql(today,engine,index_col='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "slideshow": {
     "slide_type": "-"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>changepercent</th>\n",
       "      <th>trade</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>settlement</th>\n",
       "      <th>volume</th>\n",
       "      <th>turnoverratio</th>\n",
       "      <th>amount</th>\n",
       "      <th>per</th>\n",
       "      <th>pb</th>\n",
       "      <th>mktcap</th>\n",
       "      <th>nmc</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1569</th>\n",
       "      <td>300504</td>\n",
       "      <td>N天邑</td>\n",
       "      <td>44.028</td>\n",
       "      <td>18.81</td>\n",
       "      <td>15.67</td>\n",
       "      <td>18.81</td>\n",
       "      <td>15.67</td>\n",
       "      <td>13.06</td>\n",
       "      <td>35309</td>\n",
       "      <td>0.05</td>\n",
       "      <td>656604</td>\n",
       "      <td>24.11</td>\n",
       "      <td>4.73</td>\n",
       "      <td>5.029944e+05</td>\n",
       "      <td>1.257486e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>603214</td>\n",
       "      <td>N爱婴室</td>\n",
       "      <td>44.010</td>\n",
       "      <td>28.73</td>\n",
       "      <td>23.94</td>\n",
       "      <td>28.73</td>\n",
       "      <td>23.94</td>\n",
       "      <td>19.95</td>\n",
       "      <td>19504</td>\n",
       "      <td>0.08</td>\n",
       "      <td>559871</td>\n",
       "      <td>22.98</td>\n",
       "      <td>5.76</td>\n",
       "      <td>2.873000e+05</td>\n",
       "      <td>7.182500e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1807</th>\n",
       "      <td>300263</td>\n",
       "      <td>隆华节能</td>\n",
       "      <td>10.090</td>\n",
       "      <td>6.11</td>\n",
       "      <td>5.57</td>\n",
       "      <td>6.11</td>\n",
       "      <td>5.56</td>\n",
       "      <td>5.55</td>\n",
       "      <td>47392412</td>\n",
       "      <td>9.20</td>\n",
       "      <td>284534948</td>\n",
       "      <td>353.18</td>\n",
       "      <td>2.20</td>\n",
       "      <td>5.389505e+05</td>\n",
       "      <td>3.147325e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1729</th>\n",
       "      <td>300341</td>\n",
       "      <td>麦迪电气</td>\n",
       "      <td>10.078</td>\n",
       "      <td>7.10</td>\n",
       "      <td>7.10</td>\n",
       "      <td>7.10</td>\n",
       "      <td>7.10</td>\n",
       "      <td>6.45</td>\n",
       "      <td>227600</td>\n",
       "      <td>0.06</td>\n",
       "      <td>1615960</td>\n",
       "      <td>31.68</td>\n",
       "      <td>3.45</td>\n",
       "      <td>3.622500e+05</td>\n",
       "      <td>2.633130e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2025</th>\n",
       "      <td>300043</td>\n",
       "      <td>星辉娱乐</td>\n",
       "      <td>10.075</td>\n",
       "      <td>5.90</td>\n",
       "      <td>5.52</td>\n",
       "      <td>5.90</td>\n",
       "      <td>5.42</td>\n",
       "      <td>5.36</td>\n",
       "      <td>40882584</td>\n",
       "      <td>4.96</td>\n",
       "      <td>235661658</td>\n",
       "      <td>15.95</td>\n",
       "      <td>2.87</td>\n",
       "      <td>7.340771e+05</td>\n",
       "      <td>4.860831e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3214</th>\n",
       "      <td>000670</td>\n",
       "      <td>盈方微</td>\n",
       "      <td>10.073</td>\n",
       "      <td>6.01</td>\n",
       "      <td>5.51</td>\n",
       "      <td>6.01</td>\n",
       "      <td>5.45</td>\n",
       "      <td>5.46</td>\n",
       "      <td>69452445</td>\n",
       "      <td>11.57</td>\n",
       "      <td>403229320</td>\n",
       "      <td>203.04</td>\n",
       "      <td>7.20</td>\n",
       "      <td>4.907930e+05</td>\n",
       "      <td>3.607005e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>881</th>\n",
       "      <td>600602</td>\n",
       "      <td>云赛智联</td>\n",
       "      <td>10.056</td>\n",
       "      <td>7.88</td>\n",
       "      <td>7.19</td>\n",
       "      <td>7.88</td>\n",
       "      <td>7.16</td>\n",
       "      <td>7.16</td>\n",
       "      <td>24120879</td>\n",
       "      <td>2.74</td>\n",
       "      <td>183342548</td>\n",
       "      <td>38.07</td>\n",
       "      <td>2.82</td>\n",
       "      <td>1.077727e+06</td>\n",
       "      <td>6.931032e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <td>603067</td>\n",
       "      <td>振华股份</td>\n",
       "      <td>10.038</td>\n",
       "      <td>14.47</td>\n",
       "      <td>13.15</td>\n",
       "      <td>14.47</td>\n",
       "      <td>12.82</td>\n",
       "      <td>13.15</td>\n",
       "      <td>26558607</td>\n",
       "      <td>23.89</td>\n",
       "      <td>367868668</td>\n",
       "      <td>31.46</td>\n",
       "      <td>2.85</td>\n",
       "      <td>3.183400e+05</td>\n",
       "      <td>1.608333e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2933</th>\n",
       "      <td>002045</td>\n",
       "      <td>国光电器</td>\n",
       "      <td>10.035</td>\n",
       "      <td>12.72</td>\n",
       "      <td>11.66</td>\n",
       "      <td>12.72</td>\n",
       "      <td>11.66</td>\n",
       "      <td>11.56</td>\n",
       "      <td>24284362</td>\n",
       "      <td>5.84</td>\n",
       "      <td>302122341</td>\n",
       "      <td>90.86</td>\n",
       "      <td>3.78</td>\n",
       "      <td>5.303019e+05</td>\n",
       "      <td>5.287523e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1239</th>\n",
       "      <td>600136</td>\n",
       "      <td>当代明诚</td>\n",
       "      <td>10.034</td>\n",
       "      <td>16.34</td>\n",
       "      <td>14.80</td>\n",
       "      <td>16.34</td>\n",
       "      <td>14.66</td>\n",
       "      <td>14.85</td>\n",
       "      <td>14971071</td>\n",
       "      <td>4.86</td>\n",
       "      <td>233938896</td>\n",
       "      <td>62.85</td>\n",
       "      <td>3.15</td>\n",
       "      <td>7.960557e+05</td>\n",
       "      <td>5.028541e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2227</th>\n",
       "      <td>002758</td>\n",
       "      <td>华通医药</td>\n",
       "      <td>10.030</td>\n",
       "      <td>10.86</td>\n",
       "      <td>10.00</td>\n",
       "      <td>10.86</td>\n",
       "      <td>9.91</td>\n",
       "      <td>9.87</td>\n",
       "      <td>8814860</td>\n",
       "      <td>7.10</td>\n",
       "      <td>91729695</td>\n",
       "      <td>37.45</td>\n",
       "      <td>3.98</td>\n",
       "      <td>2.280600e+05</td>\n",
       "      <td>1.347870e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>603803</td>\n",
       "      <td>瑞斯康达</td>\n",
       "      <td>10.028</td>\n",
       "      <td>19.64</td>\n",
       "      <td>19.64</td>\n",
       "      <td>19.64</td>\n",
       "      <td>19.64</td>\n",
       "      <td>17.85</td>\n",
       "      <td>1538515</td>\n",
       "      <td>2.71</td>\n",
       "      <td>30216435</td>\n",
       "      <td>28.06</td>\n",
       "      <td>3.43</td>\n",
       "      <td>8.269531e+05</td>\n",
       "      <td>1.115552e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1660</th>\n",
       "      <td>300412</td>\n",
       "      <td>迦南科技</td>\n",
       "      <td>10.027</td>\n",
       "      <td>12.07</td>\n",
       "      <td>11.60</td>\n",
       "      <td>12.07</td>\n",
       "      <td>10.93</td>\n",
       "      <td>10.97</td>\n",
       "      <td>12884352</td>\n",
       "      <td>5.84</td>\n",
       "      <td>149672158</td>\n",
       "      <td>25.15</td>\n",
       "      <td>4.16</td>\n",
       "      <td>3.140505e+05</td>\n",
       "      <td>2.664553e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1580</th>\n",
       "      <td>300493</td>\n",
       "      <td>润欣科技</td>\n",
       "      <td>10.024</td>\n",
       "      <td>13.83</td>\n",
       "      <td>12.71</td>\n",
       "      <td>13.83</td>\n",
       "      <td>12.59</td>\n",
       "      <td>12.57</td>\n",
       "      <td>8367475</td>\n",
       "      <td>5.42</td>\n",
       "      <td>111448871</td>\n",
       "      <td>33.73</td>\n",
       "      <td>8.44</td>\n",
       "      <td>4.149000e+05</td>\n",
       "      <td>2.136942e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1772</th>\n",
       "      <td>300298</td>\n",
       "      <td>三诺生物</td>\n",
       "      <td>10.018</td>\n",
       "      <td>24.16</td>\n",
       "      <td>22.05</td>\n",
       "      <td>24.16</td>\n",
       "      <td>22.00</td>\n",
       "      <td>21.96</td>\n",
       "      <td>8981717</td>\n",
       "      <td>2.91</td>\n",
       "      <td>211758281</td>\n",
       "      <td>66.91</td>\n",
       "      <td>7.38</td>\n",
       "      <td>1.138167e+06</td>\n",
       "      <td>7.458906e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1908</th>\n",
       "      <td>300161</td>\n",
       "      <td>华中数控</td>\n",
       "      <td>10.018</td>\n",
       "      <td>18.56</td>\n",
       "      <td>17.56</td>\n",
       "      <td>18.56</td>\n",
       "      <td>17.27</td>\n",
       "      <td>16.87</td>\n",
       "      <td>24083817</td>\n",
       "      <td>14.56</td>\n",
       "      <td>428260117</td>\n",
       "      <td>97.58</td>\n",
       "      <td>2.80</td>\n",
       "      <td>3.207004e+05</td>\n",
       "      <td>3.069941e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2765</th>\n",
       "      <td>002213</td>\n",
       "      <td>特 尔 佳</td>\n",
       "      <td>10.016</td>\n",
       "      <td>13.62</td>\n",
       "      <td>13.33</td>\n",
       "      <td>13.62</td>\n",
       "      <td>13.12</td>\n",
       "      <td>12.38</td>\n",
       "      <td>2242120</td>\n",
       "      <td>1.19</td>\n",
       "      <td>30429125</td>\n",
       "      <td>340.50</td>\n",
       "      <td>7.64</td>\n",
       "      <td>2.805720e+05</td>\n",
       "      <td>2.558114e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1573</th>\n",
       "      <td>300500</td>\n",
       "      <td>启迪设计</td>\n",
       "      <td>10.016</td>\n",
       "      <td>35.04</td>\n",
       "      <td>32.40</td>\n",
       "      <td>35.04</td>\n",
       "      <td>32.00</td>\n",
       "      <td>31.85</td>\n",
       "      <td>7996164</td>\n",
       "      <td>18.44</td>\n",
       "      <td>277598085</td>\n",
       "      <td>32.75</td>\n",
       "      <td>5.83</td>\n",
       "      <td>4.705155e+05</td>\n",
       "      <td>1.519475e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2147</th>\n",
       "      <td>002845</td>\n",
       "      <td>同兴达</td>\n",
       "      <td>10.014</td>\n",
       "      <td>23.18</td>\n",
       "      <td>21.07</td>\n",
       "      <td>23.18</td>\n",
       "      <td>21.07</td>\n",
       "      <td>21.07</td>\n",
       "      <td>4690108</td>\n",
       "      <td>7.52</td>\n",
       "      <td>104757082</td>\n",
       "      <td>30.10</td>\n",
       "      <td>4.69</td>\n",
       "      <td>4.667246e+05</td>\n",
       "      <td>1.446432e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>603722</td>\n",
       "      <td>阿科力</td>\n",
       "      <td>10.012</td>\n",
       "      <td>37.25</td>\n",
       "      <td>37.25</td>\n",
       "      <td>37.25</td>\n",
       "      <td>37.25</td>\n",
       "      <td>33.86</td>\n",
       "      <td>1309683</td>\n",
       "      <td>6.04</td>\n",
       "      <td>48785692</td>\n",
       "      <td>52.47</td>\n",
       "      <td>8.15</td>\n",
       "      <td>3.229575e+05</td>\n",
       "      <td>8.083250e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2106</th>\n",
       "      <td>002888</td>\n",
       "      <td>惠威科技</td>\n",
       "      <td>10.012</td>\n",
       "      <td>28.35</td>\n",
       "      <td>28.26</td>\n",
       "      <td>28.35</td>\n",
       "      <td>28.26</td>\n",
       "      <td>25.77</td>\n",
       "      <td>2068570</td>\n",
       "      <td>9.95</td>\n",
       "      <td>58600190</td>\n",
       "      <td>60.32</td>\n",
       "      <td>5.58</td>\n",
       "      <td>2.356384e+05</td>\n",
       "      <td>5.891130e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2032</th>\n",
       "      <td>300036</td>\n",
       "      <td>超图软件</td>\n",
       "      <td>10.011</td>\n",
       "      <td>20.77</td>\n",
       "      <td>19.08</td>\n",
       "      <td>20.77</td>\n",
       "      <td>18.82</td>\n",
       "      <td>18.88</td>\n",
       "      <td>47893124</td>\n",
       "      <td>14.51</td>\n",
       "      <td>954395890</td>\n",
       "      <td>47.20</td>\n",
       "      <td>5.17</td>\n",
       "      <td>9.336891e+05</td>\n",
       "      <td>6.855244e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1183</th>\n",
       "      <td>600206</td>\n",
       "      <td>有研新材</td>\n",
       "      <td>10.010</td>\n",
       "      <td>10.66</td>\n",
       "      <td>9.80</td>\n",
       "      <td>10.66</td>\n",
       "      <td>9.77</td>\n",
       "      <td>9.69</td>\n",
       "      <td>67076992</td>\n",
       "      <td>8.00</td>\n",
       "      <td>698661541</td>\n",
       "      <td>213.20</td>\n",
       "      <td>3.13</td>\n",
       "      <td>9.029855e+05</td>\n",
       "      <td>8.941377e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1670</th>\n",
       "      <td>300402</td>\n",
       "      <td>宝色股份</td>\n",
       "      <td>10.009</td>\n",
       "      <td>12.09</td>\n",
       "      <td>11.16</td>\n",
       "      <td>12.09</td>\n",
       "      <td>11.01</td>\n",
       "      <td>10.99</td>\n",
       "      <td>5008349</td>\n",
       "      <td>5.80</td>\n",
       "      <td>58679861</td>\n",
       "      <td>-24.67</td>\n",
       "      <td>4.13</td>\n",
       "      <td>2.442180e+05</td>\n",
       "      <td>1.043367e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>603976</td>\n",
       "      <td>正川股份</td>\n",
       "      <td>10.008</td>\n",
       "      <td>26.60</td>\n",
       "      <td>24.29</td>\n",
       "      <td>26.60</td>\n",
       "      <td>24.29</td>\n",
       "      <td>24.18</td>\n",
       "      <td>4425950</td>\n",
       "      <td>16.39</td>\n",
       "      <td>112984287</td>\n",
       "      <td>30.57</td>\n",
       "      <td>3.06</td>\n",
       "      <td>2.872800e+05</td>\n",
       "      <td>7.182000e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2081</th>\n",
       "      <td>002916</td>\n",
       "      <td>深南电路</td>\n",
       "      <td>10.007</td>\n",
       "      <td>78.27</td>\n",
       "      <td>72.10</td>\n",
       "      <td>78.27</td>\n",
       "      <td>72.10</td>\n",
       "      <td>71.15</td>\n",
       "      <td>15515656</td>\n",
       "      <td>22.17</td>\n",
       "      <td>1184308824</td>\n",
       "      <td>36.75</td>\n",
       "      <td>6.92</td>\n",
       "      <td>2.191560e+06</td>\n",
       "      <td>5.478900e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1566</th>\n",
       "      <td>300507</td>\n",
       "      <td>苏奥传感</td>\n",
       "      <td>10.007</td>\n",
       "      <td>31.00</td>\n",
       "      <td>28.40</td>\n",
       "      <td>31.00</td>\n",
       "      <td>28.26</td>\n",
       "      <td>28.18</td>\n",
       "      <td>3757519</td>\n",
       "      <td>6.55</td>\n",
       "      <td>111661231</td>\n",
       "      <td>36.91</td>\n",
       "      <td>4.28</td>\n",
       "      <td>3.720186e+05</td>\n",
       "      <td>1.779627e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1359</th>\n",
       "      <td>300726</td>\n",
       "      <td>宏达电子</td>\n",
       "      <td>10.006</td>\n",
       "      <td>38.15</td>\n",
       "      <td>33.66</td>\n",
       "      <td>38.15</td>\n",
       "      <td>33.33</td>\n",
       "      <td>34.68</td>\n",
       "      <td>18716117</td>\n",
       "      <td>46.67</td>\n",
       "      <td>665228911</td>\n",
       "      <td>69.83</td>\n",
       "      <td>15.08</td>\n",
       "      <td>1.526382e+06</td>\n",
       "      <td>1.529815e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1968</th>\n",
       "      <td>300101</td>\n",
       "      <td>振芯科技</td>\n",
       "      <td>10.006</td>\n",
       "      <td>17.37</td>\n",
       "      <td>15.85</td>\n",
       "      <td>17.37</td>\n",
       "      <td>15.85</td>\n",
       "      <td>15.79</td>\n",
       "      <td>46266591</td>\n",
       "      <td>8.42</td>\n",
       "      <td>782158650</td>\n",
       "      <td>316.39</td>\n",
       "      <td>11.16</td>\n",
       "      <td>9.657720e+05</td>\n",
       "      <td>9.544134e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1511</th>\n",
       "      <td>300565</td>\n",
       "      <td>科信技术</td>\n",
       "      <td>10.005</td>\n",
       "      <td>20.67</td>\n",
       "      <td>18.90</td>\n",
       "      <td>20.67</td>\n",
       "      <td>18.90</td>\n",
       "      <td>18.79</td>\n",
       "      <td>5103093</td>\n",
       "      <td>9.35</td>\n",
       "      <td>102420727</td>\n",
       "      <td>41.34</td>\n",
       "      <td>4.54</td>\n",
       "      <td>3.307200e+05</td>\n",
       "      <td>1.128417e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1186</th>\n",
       "      <td>600201</td>\n",
       "      <td>生物股份</td>\n",
       "      <td>-2.597</td>\n",
       "      <td>27.38</td>\n",
       "      <td>28.22</td>\n",
       "      <td>28.22</td>\n",
       "      <td>26.64</td>\n",
       "      <td>28.11</td>\n",
       "      <td>21148171</td>\n",
       "      <td>2.46</td>\n",
       "      <td>571678805</td>\n",
       "      <td>24.67</td>\n",
       "      <td>4.19</td>\n",
       "      <td>2.461882e+06</td>\n",
       "      <td>2.350336e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>810</th>\n",
       "      <td>600689</td>\n",
       "      <td>上海三毛</td>\n",
       "      <td>-2.671</td>\n",
       "      <td>14.21</td>\n",
       "      <td>13.76</td>\n",
       "      <td>15.43</td>\n",
       "      <td>13.57</td>\n",
       "      <td>14.60</td>\n",
       "      <td>33152724</td>\n",
       "      <td>21.78</td>\n",
       "      <td>469413364</td>\n",
       "      <td>30.89</td>\n",
       "      <td>5.99</td>\n",
       "      <td>2.856087e+05</td>\n",
       "      <td>2.162821e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2655</th>\n",
       "      <td>002324</td>\n",
       "      <td>普利特</td>\n",
       "      <td>-2.700</td>\n",
       "      <td>22.70</td>\n",
       "      <td>22.91</td>\n",
       "      <td>23.38</td>\n",
       "      <td>22.69</td>\n",
       "      <td>23.33</td>\n",
       "      <td>667608</td>\n",
       "      <td>0.42</td>\n",
       "      <td>15344005</td>\n",
       "      <td>22.04</td>\n",
       "      <td>2.75</td>\n",
       "      <td>6.148295e+05</td>\n",
       "      <td>3.614192e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3164</th>\n",
       "      <td>000732</td>\n",
       "      <td>泰禾集团</td>\n",
       "      <td>-2.707</td>\n",
       "      <td>27.68</td>\n",
       "      <td>28.74</td>\n",
       "      <td>28.74</td>\n",
       "      <td>27.37</td>\n",
       "      <td>28.45</td>\n",
       "      <td>42090625</td>\n",
       "      <td>3.39</td>\n",
       "      <td>1175438958</td>\n",
       "      <td>20.18</td>\n",
       "      <td>2.25</td>\n",
       "      <td>3.444640e+06</td>\n",
       "      <td>3.440789e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>603355</td>\n",
       "      <td>莱克电气</td>\n",
       "      <td>-2.719</td>\n",
       "      <td>32.20</td>\n",
       "      <td>33.39</td>\n",
       "      <td>33.39</td>\n",
       "      <td>31.75</td>\n",
       "      <td>33.10</td>\n",
       "      <td>2461916</td>\n",
       "      <td>3.69</td>\n",
       "      <td>79221993</td>\n",
       "      <td>25.76</td>\n",
       "      <td>4.10</td>\n",
       "      <td>1.291220e+06</td>\n",
       "      <td>2.147418e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1041</th>\n",
       "      <td>600383</td>\n",
       "      <td>金地集团</td>\n",
       "      <td>-2.752</td>\n",
       "      <td>11.66</td>\n",
       "      <td>11.86</td>\n",
       "      <td>11.89</td>\n",
       "      <td>11.60</td>\n",
       "      <td>11.99</td>\n",
       "      <td>32549159</td>\n",
       "      <td>0.72</td>\n",
       "      <td>381941636</td>\n",
       "      <td>8.33</td>\n",
       "      <td>1.43</td>\n",
       "      <td>5.264004e+06</td>\n",
       "      <td>5.264004e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2734</th>\n",
       "      <td>002244</td>\n",
       "      <td>滨江集团</td>\n",
       "      <td>-2.763</td>\n",
       "      <td>7.39</td>\n",
       "      <td>7.54</td>\n",
       "      <td>7.61</td>\n",
       "      <td>7.38</td>\n",
       "      <td>7.60</td>\n",
       "      <td>53384504</td>\n",
       "      <td>1.98</td>\n",
       "      <td>397593527</td>\n",
       "      <td>13.44</td>\n",
       "      <td>1.61</td>\n",
       "      <td>2.299357e+06</td>\n",
       "      <td>1.997446e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1551</th>\n",
       "      <td>300522</td>\n",
       "      <td>世名科技</td>\n",
       "      <td>-2.771</td>\n",
       "      <td>21.05</td>\n",
       "      <td>20.99</td>\n",
       "      <td>21.37</td>\n",
       "      <td>20.63</td>\n",
       "      <td>21.65</td>\n",
       "      <td>6240307</td>\n",
       "      <td>11.98</td>\n",
       "      <td>130729365</td>\n",
       "      <td>18.96</td>\n",
       "      <td>4.33</td>\n",
       "      <td>2.526126e+05</td>\n",
       "      <td>1.096224e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2254</th>\n",
       "      <td>002729</td>\n",
       "      <td>好利来</td>\n",
       "      <td>-2.830</td>\n",
       "      <td>35.71</td>\n",
       "      <td>35.30</td>\n",
       "      <td>36.00</td>\n",
       "      <td>35.00</td>\n",
       "      <td>36.75</td>\n",
       "      <td>3695199</td>\n",
       "      <td>5.54</td>\n",
       "      <td>131135510</td>\n",
       "      <td>105.03</td>\n",
       "      <td>5.69</td>\n",
       "      <td>2.381143e+05</td>\n",
       "      <td>2.381143e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2778</th>\n",
       "      <td>002200</td>\n",
       "      <td>云投生态</td>\n",
       "      <td>-2.887</td>\n",
       "      <td>10.09</td>\n",
       "      <td>10.15</td>\n",
       "      <td>10.30</td>\n",
       "      <td>10.00</td>\n",
       "      <td>10.39</td>\n",
       "      <td>4392407</td>\n",
       "      <td>3.12</td>\n",
       "      <td>44561267</td>\n",
       "      <td>55.56</td>\n",
       "      <td>2.29</td>\n",
       "      <td>1.857901e+05</td>\n",
       "      <td>1.421428e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1042</th>\n",
       "      <td>600382</td>\n",
       "      <td>广东明珠</td>\n",
       "      <td>-2.930</td>\n",
       "      <td>12.26</td>\n",
       "      <td>12.41</td>\n",
       "      <td>12.44</td>\n",
       "      <td>12.13</td>\n",
       "      <td>12.63</td>\n",
       "      <td>7451589</td>\n",
       "      <td>2.18</td>\n",
       "      <td>91337531</td>\n",
       "      <td>17.27</td>\n",
       "      <td>1.14</td>\n",
       "      <td>5.723271e+05</td>\n",
       "      <td>4.189813e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1893</th>\n",
       "      <td>300176</td>\n",
       "      <td>鸿特精密</td>\n",
       "      <td>-3.008</td>\n",
       "      <td>140.93</td>\n",
       "      <td>145.55</td>\n",
       "      <td>146.78</td>\n",
       "      <td>140.61</td>\n",
       "      <td>145.30</td>\n",
       "      <td>1893699</td>\n",
       "      <td>1.77</td>\n",
       "      <td>270303298</td>\n",
       "      <td>301.71</td>\n",
       "      <td>16.86</td>\n",
       "      <td>1.511897e+06</td>\n",
       "      <td>1.507651e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2280</th>\n",
       "      <td>002700</td>\n",
       "      <td>新疆浩源</td>\n",
       "      <td>-3.037</td>\n",
       "      <td>8.30</td>\n",
       "      <td>8.58</td>\n",
       "      <td>8.58</td>\n",
       "      <td>8.23</td>\n",
       "      <td>8.56</td>\n",
       "      <td>3869432</td>\n",
       "      <td>1.24</td>\n",
       "      <td>32234722</td>\n",
       "      <td>46.11</td>\n",
       "      <td>3.74</td>\n",
       "      <td>3.506143e+05</td>\n",
       "      <td>2.598675e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2133</th>\n",
       "      <td>002860</td>\n",
       "      <td>星帅尔</td>\n",
       "      <td>-3.091</td>\n",
       "      <td>41.70</td>\n",
       "      <td>41.10</td>\n",
       "      <td>42.30</td>\n",
       "      <td>40.70</td>\n",
       "      <td>43.03</td>\n",
       "      <td>3952313</td>\n",
       "      <td>26.00</td>\n",
       "      <td>164052198</td>\n",
       "      <td>33.09</td>\n",
       "      <td>4.98</td>\n",
       "      <td>3.168311e+05</td>\n",
       "      <td>6.338400e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2917</th>\n",
       "      <td>002061</td>\n",
       "      <td>浙江交科</td>\n",
       "      <td>-3.175</td>\n",
       "      <td>12.81</td>\n",
       "      <td>13.20</td>\n",
       "      <td>13.21</td>\n",
       "      <td>12.63</td>\n",
       "      <td>13.23</td>\n",
       "      <td>7564420</td>\n",
       "      <td>1.67</td>\n",
       "      <td>97160875</td>\n",
       "      <td>106.75</td>\n",
       "      <td>2.97</td>\n",
       "      <td>1.672008e+06</td>\n",
       "      <td>5.806002e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3328</th>\n",
       "      <td>000517</td>\n",
       "      <td>荣安地产</td>\n",
       "      <td>-3.211</td>\n",
       "      <td>4.22</td>\n",
       "      <td>4.35</td>\n",
       "      <td>4.35</td>\n",
       "      <td>4.20</td>\n",
       "      <td>4.36</td>\n",
       "      <td>68044728</td>\n",
       "      <td>2.24</td>\n",
       "      <td>289151639</td>\n",
       "      <td>24.79</td>\n",
       "      <td>3.19</td>\n",
       "      <td>1.343615e+06</td>\n",
       "      <td>1.281030e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3223</th>\n",
       "      <td>000659</td>\n",
       "      <td>*ST中富</td>\n",
       "      <td>-3.368</td>\n",
       "      <td>3.73</td>\n",
       "      <td>3.85</td>\n",
       "      <td>3.93</td>\n",
       "      <td>3.68</td>\n",
       "      <td>3.86</td>\n",
       "      <td>19720366</td>\n",
       "      <td>1.53</td>\n",
       "      <td>74379824</td>\n",
       "      <td>53.29</td>\n",
       "      <td>7.29</td>\n",
       "      <td>4.795670e+05</td>\n",
       "      <td>4.795670e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>601601</td>\n",
       "      <td>中国太保</td>\n",
       "      <td>-3.498</td>\n",
       "      <td>33.93</td>\n",
       "      <td>34.84</td>\n",
       "      <td>34.99</td>\n",
       "      <td>33.68</td>\n",
       "      <td>35.16</td>\n",
       "      <td>44748341</td>\n",
       "      <td>0.71</td>\n",
       "      <td>1526335743</td>\n",
       "      <td>20.94</td>\n",
       "      <td>2.24</td>\n",
       "      <td>3.074737e+07</td>\n",
       "      <td>2.133077e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2250</th>\n",
       "      <td>002733</td>\n",
       "      <td>雄韬股份</td>\n",
       "      <td>-3.699</td>\n",
       "      <td>13.80</td>\n",
       "      <td>14.33</td>\n",
       "      <td>14.62</td>\n",
       "      <td>13.73</td>\n",
       "      <td>14.33</td>\n",
       "      <td>7049589</td>\n",
       "      <td>2.26</td>\n",
       "      <td>98912866</td>\n",
       "      <td>37.30</td>\n",
       "      <td>2.18</td>\n",
       "      <td>4.831562e+05</td>\n",
       "      <td>4.300215e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1106</th>\n",
       "      <td>600306</td>\n",
       "      <td>商业城</td>\n",
       "      <td>-4.015</td>\n",
       "      <td>10.04</td>\n",
       "      <td>10.21</td>\n",
       "      <td>10.46</td>\n",
       "      <td>9.68</td>\n",
       "      <td>10.46</td>\n",
       "      <td>11698728</td>\n",
       "      <td>6.59</td>\n",
       "      <td>117796440</td>\n",
       "      <td>21.70</td>\n",
       "      <td>11.98</td>\n",
       "      <td>1.788515e+05</td>\n",
       "      <td>1.781153e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1954</th>\n",
       "      <td>300115</td>\n",
       "      <td>长盈精密</td>\n",
       "      <td>-4.081</td>\n",
       "      <td>18.57</td>\n",
       "      <td>18.71</td>\n",
       "      <td>18.86</td>\n",
       "      <td>17.67</td>\n",
       "      <td>19.36</td>\n",
       "      <td>52609047</td>\n",
       "      <td>5.81</td>\n",
       "      <td>960899099</td>\n",
       "      <td>29.48</td>\n",
       "      <td>3.83</td>\n",
       "      <td>1.688448e+06</td>\n",
       "      <td>1.681130e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>403</th>\n",
       "      <td>603021</td>\n",
       "      <td>山东华鹏</td>\n",
       "      <td>-4.545</td>\n",
       "      <td>8.82</td>\n",
       "      <td>8.90</td>\n",
       "      <td>8.94</td>\n",
       "      <td>8.68</td>\n",
       "      <td>9.24</td>\n",
       "      <td>14816771</td>\n",
       "      <td>7.13</td>\n",
       "      <td>130493072</td>\n",
       "      <td>110.25</td>\n",
       "      <td>2.09</td>\n",
       "      <td>2.821942e+05</td>\n",
       "      <td>1.833077e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3452</th>\n",
       "      <td>600871</td>\n",
       "      <td>*ST油服</td>\n",
       "      <td>-4.695</td>\n",
       "      <td>2.03</td>\n",
       "      <td>2.02</td>\n",
       "      <td>2.08</td>\n",
       "      <td>2.02</td>\n",
       "      <td>2.13</td>\n",
       "      <td>68101107</td>\n",
       "      <td>0.57</td>\n",
       "      <td>138518864</td>\n",
       "      <td>-2.71</td>\n",
       "      <td>-13.65</td>\n",
       "      <td>3.853821e+06</td>\n",
       "      <td>2.444660e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2657</th>\n",
       "      <td>002322</td>\n",
       "      <td>理工环科</td>\n",
       "      <td>-4.762</td>\n",
       "      <td>16.00</td>\n",
       "      <td>15.65</td>\n",
       "      <td>16.21</td>\n",
       "      <td>15.38</td>\n",
       "      <td>16.80</td>\n",
       "      <td>13977845</td>\n",
       "      <td>4.88</td>\n",
       "      <td>221103444</td>\n",
       "      <td>42.10</td>\n",
       "      <td>2.11</td>\n",
       "      <td>6.368550e+05</td>\n",
       "      <td>4.579319e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3461</th>\n",
       "      <td>600767</td>\n",
       "      <td>*ST运盛</td>\n",
       "      <td>-4.985</td>\n",
       "      <td>6.48</td>\n",
       "      <td>6.48</td>\n",
       "      <td>6.62</td>\n",
       "      <td>6.48</td>\n",
       "      <td>6.82</td>\n",
       "      <td>9202858</td>\n",
       "      <td>2.70</td>\n",
       "      <td>59871127</td>\n",
       "      <td>51.02</td>\n",
       "      <td>9.71</td>\n",
       "      <td>2.209746e+05</td>\n",
       "      <td>2.209098e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2552</th>\n",
       "      <td>002427</td>\n",
       "      <td>ST尤夫</td>\n",
       "      <td>-4.986</td>\n",
       "      <td>20.58</td>\n",
       "      <td>20.58</td>\n",
       "      <td>20.58</td>\n",
       "      <td>20.58</td>\n",
       "      <td>21.66</td>\n",
       "      <td>62500</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1286250</td>\n",
       "      <td>49.00</td>\n",
       "      <td>3.40</td>\n",
       "      <td>8.194023e+05</td>\n",
       "      <td>8.193923e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3195</th>\n",
       "      <td>000693</td>\n",
       "      <td>*ST华泽</td>\n",
       "      <td>-5.034</td>\n",
       "      <td>8.30</td>\n",
       "      <td>8.30</td>\n",
       "      <td>8.30</td>\n",
       "      <td>8.30</td>\n",
       "      <td>8.74</td>\n",
       "      <td>106600</td>\n",
       "      <td>0.04</td>\n",
       "      <td>884780</td>\n",
       "      <td>-12.26</td>\n",
       "      <td>6.13</td>\n",
       "      <td>4.510983e+05</td>\n",
       "      <td>2.302048e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1502</th>\n",
       "      <td>300575</td>\n",
       "      <td>中旗股份</td>\n",
       "      <td>-5.313</td>\n",
       "      <td>41.70</td>\n",
       "      <td>39.70</td>\n",
       "      <td>42.74</td>\n",
       "      <td>39.66</td>\n",
       "      <td>44.04</td>\n",
       "      <td>3555557</td>\n",
       "      <td>10.34</td>\n",
       "      <td>144990088</td>\n",
       "      <td>26.06</td>\n",
       "      <td>3.15</td>\n",
       "      <td>3.058695e+05</td>\n",
       "      <td>1.434106e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2073</th>\n",
       "      <td>002925</td>\n",
       "      <td>盈趣科技</td>\n",
       "      <td>-6.409</td>\n",
       "      <td>84.70</td>\n",
       "      <td>81.45</td>\n",
       "      <td>85.50</td>\n",
       "      <td>81.45</td>\n",
       "      <td>90.50</td>\n",
       "      <td>18980629</td>\n",
       "      <td>25.31</td>\n",
       "      <td>1572816590</td>\n",
       "      <td>32.70</td>\n",
       "      <td>22.52</td>\n",
       "      <td>3.855205e+06</td>\n",
       "      <td>6.352500e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393</th>\n",
       "      <td>603032</td>\n",
       "      <td>德新交运</td>\n",
       "      <td>-10.007</td>\n",
       "      <td>48.83</td>\n",
       "      <td>52.00</td>\n",
       "      <td>55.00</td>\n",
       "      <td>48.83</td>\n",
       "      <td>54.26</td>\n",
       "      <td>7569468</td>\n",
       "      <td>11.58</td>\n",
       "      <td>376636931</td>\n",
       "      <td>95.75</td>\n",
       "      <td>15.18</td>\n",
       "      <td>6.510992e+05</td>\n",
       "      <td>3.190552e+05</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3509 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         code   name  changepercent   trade    open    high     low  \\\n",
       "index                                                                 \n",
       "1569   300504    N天邑         44.028   18.81   15.67   18.81   15.67   \n",
       "309    603214   N爱婴室         44.010   28.73   23.94   28.73   23.94   \n",
       "1807   300263   隆华节能         10.090    6.11    5.57    6.11    5.56   \n",
       "1729   300341   麦迪电气         10.078    7.10    7.10    7.10    7.10   \n",
       "2025   300043   星辉娱乐         10.075    5.90    5.52    5.90    5.42   \n",
       "3214   000670    盈方微         10.073    6.01    5.51    6.01    5.45   \n",
       "881    600602   云赛智联         10.056    7.88    7.19    7.88    7.16   \n",
       "374    603067   振华股份         10.038   14.47   13.15   14.47   12.82   \n",
       "2933   002045   国光电器         10.035   12.72   11.66   12.72   11.66   \n",
       "1239   600136   当代明诚         10.034   16.34   14.80   16.34   14.66   \n",
       "2227   002758   华通医药         10.030   10.86   10.00   10.86    9.91   \n",
       "94     603803   瑞斯康达         10.028   19.64   19.64   19.64   19.64   \n",
       "1660   300412   迦南科技         10.027   12.07   11.60   12.07   10.93   \n",
       "1580   300493   润欣科技         10.024   13.83   12.71   13.83   12.59   \n",
       "1772   300298   三诺生物         10.018   24.16   22.05   24.16   22.00   \n",
       "1908   300161   华中数控         10.018   18.56   17.56   18.56   17.27   \n",
       "2765   002213  特 尔 佳         10.016   13.62   13.33   13.62   13.12   \n",
       "1573   300500   启迪设计         10.016   35.04   32.40   35.04   32.00   \n",
       "2147   002845    同兴达         10.014   23.18   21.07   23.18   21.07   \n",
       "120    603722    阿科力         10.012   37.25   37.25   37.25   37.25   \n",
       "2106   002888   惠威科技         10.012   28.35   28.26   28.35   28.26   \n",
       "2032   300036   超图软件         10.011   20.77   19.08   20.77   18.82   \n",
       "1183   600206   有研新材         10.010   10.66    9.80   10.66    9.77   \n",
       "1670   300402   宝色股份         10.009   12.09   11.16   12.09   11.01   \n",
       "16     603976   正川股份         10.008   26.60   24.29   26.60   24.29   \n",
       "2081   002916   深南电路         10.007   78.27   72.10   78.27   72.10   \n",
       "1566   300507   苏奥传感         10.007   31.00   28.40   31.00   28.26   \n",
       "1359   300726   宏达电子         10.006   38.15   33.66   38.15   33.33   \n",
       "1968   300101   振芯科技         10.006   17.37   15.85   17.37   15.85   \n",
       "1511   300565   科信技术         10.005   20.67   18.90   20.67   18.90   \n",
       "...       ...    ...            ...     ...     ...     ...     ...   \n",
       "1186   600201   生物股份         -2.597   27.38   28.22   28.22   26.64   \n",
       "810    600689   上海三毛         -2.671   14.21   13.76   15.43   13.57   \n",
       "2655   002324    普利特         -2.700   22.70   22.91   23.38   22.69   \n",
       "3164   000732   泰禾集团         -2.707   27.68   28.74   28.74   27.37   \n",
       "255    603355   莱克电气         -2.719   32.20   33.39   33.39   31.75   \n",
       "1041   600383   金地集团         -2.752   11.66   11.86   11.89   11.60   \n",
       "2734   002244   滨江集团         -2.763    7.39    7.54    7.61    7.38   \n",
       "1551   300522   世名科技         -2.771   21.05   20.99   21.37   20.63   \n",
       "2254   002729    好利来         -2.830   35.71   35.30   36.00   35.00   \n",
       "2778   002200   云投生态         -2.887   10.09   10.15   10.30   10.00   \n",
       "1042   600382   广东明珠         -2.930   12.26   12.41   12.44   12.13   \n",
       "1893   300176   鸿特精密         -3.008  140.93  145.55  146.78  140.61   \n",
       "2280   002700   新疆浩源         -3.037    8.30    8.58    8.58    8.23   \n",
       "2133   002860    星帅尔         -3.091   41.70   41.10   42.30   40.70   \n",
       "2917   002061   浙江交科         -3.175   12.81   13.20   13.21   12.63   \n",
       "3328   000517   荣安地产         -3.211    4.22    4.35    4.35    4.20   \n",
       "3223   000659  *ST中富         -3.368    3.73    3.85    3.93    3.68   \n",
       "495    601601   中国太保         -3.498   33.93   34.84   34.99   33.68   \n",
       "2250   002733   雄韬股份         -3.699   13.80   14.33   14.62   13.73   \n",
       "1106   600306    商业城         -4.015   10.04   10.21   10.46    9.68   \n",
       "1954   300115   长盈精密         -4.081   18.57   18.71   18.86   17.67   \n",
       "403    603021   山东华鹏         -4.545    8.82    8.90    8.94    8.68   \n",
       "3452   600871  *ST油服         -4.695    2.03    2.02    2.08    2.02   \n",
       "2657   002322   理工环科         -4.762   16.00   15.65   16.21   15.38   \n",
       "3461   600767  *ST运盛         -4.985    6.48    6.48    6.62    6.48   \n",
       "2552   002427   ST尤夫         -4.986   20.58   20.58   20.58   20.58   \n",
       "3195   000693  *ST华泽         -5.034    8.30    8.30    8.30    8.30   \n",
       "1502   300575   中旗股份         -5.313   41.70   39.70   42.74   39.66   \n",
       "2073   002925   盈趣科技         -6.409   84.70   81.45   85.50   81.45   \n",
       "393    603032   德新交运        -10.007   48.83   52.00   55.00   48.83   \n",
       "\n",
       "       settlement    volume  turnoverratio      amount     per     pb  \\\n",
       "index                                                                   \n",
       "1569        13.06     35309           0.05      656604   24.11   4.73   \n",
       "309         19.95     19504           0.08      559871   22.98   5.76   \n",
       "1807         5.55  47392412           9.20   284534948  353.18   2.20   \n",
       "1729         6.45    227600           0.06     1615960   31.68   3.45   \n",
       "2025         5.36  40882584           4.96   235661658   15.95   2.87   \n",
       "3214         5.46  69452445          11.57   403229320  203.04   7.20   \n",
       "881          7.16  24120879           2.74   183342548   38.07   2.82   \n",
       "374         13.15  26558607          23.89   367868668   31.46   2.85   \n",
       "2933        11.56  24284362           5.84   302122341   90.86   3.78   \n",
       "1239        14.85  14971071           4.86   233938896   62.85   3.15   \n",
       "2227         9.87   8814860           7.10    91729695   37.45   3.98   \n",
       "94          17.85   1538515           2.71    30216435   28.06   3.43   \n",
       "1660        10.97  12884352           5.84   149672158   25.15   4.16   \n",
       "1580        12.57   8367475           5.42   111448871   33.73   8.44   \n",
       "1772        21.96   8981717           2.91   211758281   66.91   7.38   \n",
       "1908        16.87  24083817          14.56   428260117   97.58   2.80   \n",
       "2765        12.38   2242120           1.19    30429125  340.50   7.64   \n",
       "1573        31.85   7996164          18.44   277598085   32.75   5.83   \n",
       "2147        21.07   4690108           7.52   104757082   30.10   4.69   \n",
       "120         33.86   1309683           6.04    48785692   52.47   8.15   \n",
       "2106        25.77   2068570           9.95    58600190   60.32   5.58   \n",
       "2032        18.88  47893124          14.51   954395890   47.20   5.17   \n",
       "1183         9.69  67076992           8.00   698661541  213.20   3.13   \n",
       "1670        10.99   5008349           5.80    58679861  -24.67   4.13   \n",
       "16          24.18   4425950          16.39   112984287   30.57   3.06   \n",
       "2081        71.15  15515656          22.17  1184308824   36.75   6.92   \n",
       "1566        28.18   3757519           6.55   111661231   36.91   4.28   \n",
       "1359        34.68  18716117          46.67   665228911   69.83  15.08   \n",
       "1968        15.79  46266591           8.42   782158650  316.39  11.16   \n",
       "1511        18.79   5103093           9.35   102420727   41.34   4.54   \n",
       "...           ...       ...            ...         ...     ...    ...   \n",
       "1186        28.11  21148171           2.46   571678805   24.67   4.19   \n",
       "810         14.60  33152724          21.78   469413364   30.89   5.99   \n",
       "2655        23.33    667608           0.42    15344005   22.04   2.75   \n",
       "3164        28.45  42090625           3.39  1175438958   20.18   2.25   \n",
       "255         33.10   2461916           3.69    79221993   25.76   4.10   \n",
       "1041        11.99  32549159           0.72   381941636    8.33   1.43   \n",
       "2734         7.60  53384504           1.98   397593527   13.44   1.61   \n",
       "1551        21.65   6240307          11.98   130729365   18.96   4.33   \n",
       "2254        36.75   3695199           5.54   131135510  105.03   5.69   \n",
       "2778        10.39   4392407           3.12    44561267   55.56   2.29   \n",
       "1042        12.63   7451589           2.18    91337531   17.27   1.14   \n",
       "1893       145.30   1893699           1.77   270303298  301.71  16.86   \n",
       "2280         8.56   3869432           1.24    32234722   46.11   3.74   \n",
       "2133        43.03   3952313          26.00   164052198   33.09   4.98   \n",
       "2917        13.23   7564420           1.67    97160875  106.75   2.97   \n",
       "3328         4.36  68044728           2.24   289151639   24.79   3.19   \n",
       "3223         3.86  19720366           1.53    74379824   53.29   7.29   \n",
       "495         35.16  44748341           0.71  1526335743   20.94   2.24   \n",
       "2250        14.33   7049589           2.26    98912866   37.30   2.18   \n",
       "1106        10.46  11698728           6.59   117796440   21.70  11.98   \n",
       "1954        19.36  52609047           5.81   960899099   29.48   3.83   \n",
       "403          9.24  14816771           7.13   130493072  110.25   2.09   \n",
       "3452         2.13  68101107           0.57   138518864   -2.71 -13.65   \n",
       "2657        16.80  13977845           4.88   221103444   42.10   2.11   \n",
       "3461         6.82   9202858           2.70    59871127   51.02   9.71   \n",
       "2552        21.66     62500           0.02     1286250   49.00   3.40   \n",
       "3195         8.74    106600           0.04      884780  -12.26   6.13   \n",
       "1502        44.04   3555557          10.34   144990088   26.06   3.15   \n",
       "2073        90.50  18980629          25.31  1572816590   32.70  22.52   \n",
       "393         54.26   7569468          11.58   376636931   95.75  15.18   \n",
       "\n",
       "             mktcap           nmc  \n",
       "index                              \n",
       "1569   5.029944e+05  1.257486e+05  \n",
       "309    2.873000e+05  7.182500e+04  \n",
       "1807   5.389505e+05  3.147325e+05  \n",
       "1729   3.622500e+05  2.633130e+05  \n",
       "2025   7.340771e+05  4.860831e+05  \n",
       "3214   4.907930e+05  3.607005e+05  \n",
       "881    1.077727e+06  6.931032e+05  \n",
       "374    3.183400e+05  1.608333e+05  \n",
       "2933   5.303019e+05  5.287523e+05  \n",
       "1239   7.960557e+05  5.028541e+05  \n",
       "2227   2.280600e+05  1.347870e+05  \n",
       "94     8.269531e+05  1.115552e+05  \n",
       "1660   3.140505e+05  2.664553e+05  \n",
       "1580   4.149000e+05  2.136942e+05  \n",
       "1772   1.138167e+06  7.458906e+05  \n",
       "1908   3.207004e+05  3.069941e+05  \n",
       "2765   2.805720e+05  2.558114e+05  \n",
       "1573   4.705155e+05  1.519475e+05  \n",
       "2147   4.667246e+05  1.446432e+05  \n",
       "120    3.229575e+05  8.083250e+04  \n",
       "2106   2.356384e+05  5.891130e+04  \n",
       "2032   9.336891e+05  6.855244e+05  \n",
       "1183   9.029855e+05  8.941377e+05  \n",
       "1670   2.442180e+05  1.043367e+05  \n",
       "16     2.872800e+05  7.182000e+04  \n",
       "2081   2.191560e+06  5.478900e+05  \n",
       "1566   3.720186e+05  1.779627e+05  \n",
       "1359   1.526382e+06  1.529815e+05  \n",
       "1968   9.657720e+05  9.544134e+05  \n",
       "1511   3.307200e+05  1.128417e+05  \n",
       "...             ...           ...  \n",
       "1186   2.461882e+06  2.350336e+06  \n",
       "810    2.856087e+05  2.162821e+05  \n",
       "2655   6.148295e+05  3.614192e+05  \n",
       "3164   3.444640e+06  3.440789e+06  \n",
       "255    1.291220e+06  2.147418e+05  \n",
       "1041   5.264004e+06  5.264004e+06  \n",
       "2734   2.299357e+06  1.997446e+06  \n",
       "1551   2.526126e+05  1.096224e+05  \n",
       "2254   2.381143e+05  2.381143e+05  \n",
       "2778   1.857901e+05  1.421428e+05  \n",
       "1042   5.723271e+05  4.189813e+05  \n",
       "1893   1.511897e+06  1.507651e+06  \n",
       "2280   3.506143e+05  2.598675e+05  \n",
       "2133   3.168311e+05  6.338400e+04  \n",
       "2917   1.672008e+06  5.806002e+05  \n",
       "3328   1.343615e+06  1.281030e+06  \n",
       "3223   4.795670e+05  4.795670e+05  \n",
       "495    3.074737e+07  2.133077e+07  \n",
       "2250   4.831562e+05  4.300215e+05  \n",
       "1106   1.788515e+05  1.781153e+05  \n",
       "1954   1.688448e+06  1.681130e+06  \n",
       "403    2.821942e+05  1.833077e+05  \n",
       "3452   3.853821e+06  2.444660e+06  \n",
       "2657   6.368550e+05  4.579319e+05  \n",
       "3461   2.209746e+05  2.209098e+05  \n",
       "2552   8.194023e+05  8.193923e+05  \n",
       "3195   4.510983e+05  2.302048e+05  \n",
       "1502   3.058695e+05  1.434106e+05  \n",
       "2073   3.855205e+06  6.352500e+05  \n",
       "393    6.510992e+05  3.190552e+05  \n",
       "\n",
       "[3509 rows x 15 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values(by='changepercent',ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#查看黑名单个股的涨跌幅\n",
    "engine=get_engine('db_stock')\n",
    "black_list_df = pd.read_sql('tb_blacklist',engine,index_col='DATE')\n",
    "black_list_df\n",
    "df['changepercent']=map(lambda x:round(x,2),df['changepercent'])\n",
    "df['turnoverratio']=map(lambda x:round(x,0),df['turnoverratio'])\n",
    "#black_list_df['changepercent']=map(lambda x:round(x,2),black_list_df['changepercent'])\n",
    "#black_list_df['changepercent']=map(lambda x:round(x,2),black_list_df['changepercent'])\n",
    "code_list = black_list_df['CODE'].values\n",
    "black_list_percent = df[df['code'].isin(code_list)].sort_values(by='changepercent',ascending=False)\n",
    "black_list_percent"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "8.739999999999998"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "p=9.2\n",
    "sell=p*0.95\n",
    "sell"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "api=ts.get_apis()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#追踪昨日涨停的今日情况\n",
    "engine_zdt = get_engine('db_zdt')\n",
    "# zdt_today_format=datetime.datetime.now().strftime(\"%Y%m%d\")\n",
    "zdt_today_format='20180328zdt'\n",
    "zdt_df = pd.read_sql(zdt_today_format,engine_zdt,index_col='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "宏川智慧\n",
      "10.02\n",
      "彩讯股份\n",
      "9.97\n",
      "湖南盐业\n",
      "10.06\n",
      "振华股份\n",
      "10.04\n",
      "蓝晓科技\n",
      "9.99\n",
      "万集科技\n",
      "1.91\n",
      "新雷能\n",
      "0.9\n",
      "广生堂\n",
      "10.0\n",
      "新天药业\n",
      "7.95\n",
      "共进股份\n",
      "4.31\n",
      "必创科技\n",
      "6.95\n",
      "佳沃股份\n",
      "-0.51\n",
      "天喻信息\n",
      "-2.08\n",
      "宏达电子\n",
      "0.48\n",
      "美格智能\n",
      "0.52\n",
      "建新股份\n",
      "0.32\n",
      "步森股份\n",
      "-2.7\n",
      "天润乳业\n",
      "2.71\n",
      "迦南科技\n",
      "10.03\n",
      "盘龙药业\n",
      "-100.0\n",
      "好利来\n",
      "4.46\n",
      "博思软件\n",
      "10.01\n",
      "渤海股份\n",
      "1.21\n",
      "达安基因\n",
      "2.54\n",
      "创新医疗\n",
      "3.63\n",
      "赛隆药业\n",
      "-4.07\n",
      "姚记扑克\n",
      "0.35\n",
      "世名科技\n",
      "9.95\n",
      "*ST昌鱼\n",
      "-0.63\n",
      "建科院\n",
      "2.11\n",
      "鹏鹞环保\n",
      "2.39\n",
      "*ST弘高\n",
      "0.0\n",
      "新天科技\n",
      "4.64\n",
      "博济医药\n",
      "10.01\n",
      "天桥起重\n",
      "-6.79\n",
      "春风动力\n",
      "7.6\n",
      "初灵信息\n",
      "0.13\n",
      "美力科技\n",
      "-0.71\n",
      "科华生物\n",
      "-0.49\n",
      "北信源\n",
      "3.74\n",
      "通用股份\n",
      "-3.55\n",
      "广和通\n",
      "3.6\n",
      "津膜科技\n",
      "-3.28\n",
      "达志科技\n",
      "-3.06\n",
      "创业环保\n",
      "-1.6\n",
      "大东海A\n",
      "1.83\n",
      "天鹅股份\n",
      "9.98\n",
      "智能自控\n",
      "-2.47\n",
      "科创信息\n",
      "-4.32\n",
      "移为通信\n",
      "1.86\n",
      "泰永长征\n",
      "-1.24\n",
      "依米康\n",
      "6.29\n",
      "神农基因\n",
      "-2.74\n"
     ]
    }
   ],
   "source": [
    "percent_list = []\n",
    "for code in zdt_df[u'代码'].values:\n",
    "    last_price= zdt_df[zdt_df[u'代码']==code][u'最新价格'].values[0]\n",
    "    print(zdt_df[zdt_df[u'代码']==code][u'名称'].values[0]\n",)
    "    try:\n",
    "        current_price= ts.quotes(code,conn=api)['price'].values[0]\n",
    "    except:\n",
    "        continue\n",
    "        \n",
    "    percent = float(current_price-last_price)/last_price*100\n",
    "    print(round(percent,2)\n",)
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>price</th>\n",
       "      <th>last_close</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>vol</th>\n",
       "      <th>cur_vol</th>\n",
       "      <th>amount</th>\n",
       "      <th>s_vol</th>\n",
       "      <th>...</th>\n",
       "      <th>bid_vol3</th>\n",
       "      <th>ask_vol3</th>\n",
       "      <th>bid4</th>\n",
       "      <th>ask4</th>\n",
       "      <th>bid_vol4</th>\n",
       "      <th>ask_vol4</th>\n",
       "      <th>bid5</th>\n",
       "      <th>ask5</th>\n",
       "      <th>bid_vol5</th>\n",
       "      <th>ask_vol5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>300141</td>\n",
       "      <td>10.09</td>\n",
       "      <td>9.89</td>\n",
       "      <td>9.9</td>\n",
       "      <td>10.1</td>\n",
       "      <td>9.9</td>\n",
       "      <td>8895</td>\n",
       "      <td>13</td>\n",
       "      <td>8867134.0</td>\n",
       "      <td>3639</td>\n",
       "      <td>...</td>\n",
       "      <td>100</td>\n",
       "      <td>9</td>\n",
       "      <td>10.04</td>\n",
       "      <td>10.13</td>\n",
       "      <td>60</td>\n",
       "      <td>13</td>\n",
       "      <td>9.99</td>\n",
       "      <td>10.14</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     code  price  last_close  open  high  low   vol  cur_vol     amount  \\\n",
       "0  300141  10.09        9.89   9.9  10.1  9.9  8895       13  8867134.0   \n",
       "\n",
       "   s_vol    ...     bid_vol3  ask_vol3   bid4   ask4  bid_vol4  ask_vol4  \\\n",
       "0   3639    ...          100         9  10.04  10.13        60        13   \n",
       "\n",
       "   bid5   ask5  bid_vol5  ask_vol5  \n",
       "0  9.99  10.14         6         5  \n",
       "\n",
       "[1 rows x 31 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ts.quotes('300141',conn=api)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
